﻿CREATE PROCEDURE [acms].[SiteMapping_Delete]
	@Id int, 
	@ConcurencyId rowversion
AS
	Delete SiteMappings
	Where Id = @Id and ConcurencyId = @ConcurencyId
	
	if @@rowcount = 1
		RETURN 0;
	else if exists (Select null from SiteMappings where Id = @Id)
		return -100;
	else
		return -200;
	